Database Handicapping Software- JCapper

JCapper Message Board

          JCapper 101
                      -- Can this be done in SQL?

Home Register
Log In
By Can this be done in SQL?
JackB
6/30/2014
7:10:49 PM		Way out there here but..........

Let say there are 8 factors, (F01-F08 for example)

Is it possible write 1 UDM that will light up when ANY 2 (or more) of those factors have a rank of 1?



Reply
Caveat
7/1/2014
6:59:25 AM
Will this work for you ?
This is using 2 factors
more than that , I'm not sure
I know an "or" function is in there somewhere :)


code:
SQL:  SELECT * FROM STARTERHISTORY
           WHERE RANKF01 = 1 
           AND ( RANKF02 = 1 OR RANKF03 = 1 OR RANKF04 = 1 )


     Data Summary          Win         Place          Show
     -----------------------------------------------------
     Mutuel Totals   147000.50     142113.20     139384.10
     Bet            -170692.00    -170692.00    -170692.00
     -----------------------------------------------------
     P/L             -23691.50     -28578.80     -31307.90

     Wins                16831         30364         40530
     Plays               85346         85346         85346
     PCT                 .1972         .3558         .4749

     ROI                0.8612        0.8326        0.8166
     Avg Mut              8.73          4.68          3.44




~Edited by: Caveat  on:  7/1/2014  at:  6:59:25 AM~

Reply
JackB
7/2/2014
6:51:10 PM		Thanks Caveat. I'll give her a shot and see.////

You put me on the right track. Thank You very much !!

~Edited by: JackB  on:  7/2/2014  at:  6:51:10 PM~

Reply
Caveat
7/2/2014
9:26:20 PM		my pleasure

let me know how it goes
mike




~Edited by: Caveat  on:  7/2/2014  at:  9:26:20 PM~

Reply
Reply
Copyright © 2018 JCapper Software              back to the JCapper Message Board              www.JCapper.com